Model Table BUSINESS OPP
This model dimension represents the different business opportunities which is considered as the pre-step to quotation and orders and is based on the IFS Cloud dimension FACT_BUSINESS_OPP. All models that refers to this dimension will have the attributes and hierarchies as described below.
Attributes
| Attribute |
Description (where applicable) |
| Business Type | Indicates if the opportunity is regarding new or recurring sales. |
| Closed Status | Indicates if the opportunity was won or lost. |
| Description | Description of the Business Opportunity |
| DimRefDetails | Not Needed |
| Lost To | If the opportunity was lost, this is the competitor who won the deal. |
| Opportunity No | The identity number of the business opportunity |
| Opportunity Source | The origin of the opportunity. |
| Opportunity Type | Specifies the nature of the opportunity. |
| Opportunity Type Description | Specifies the nature of the opportunity. |
| Reason Note | A note which was added when the opportunity was closed. |
| Reference Type ID | Not Needed |
| State | The status of the Business Opportunity. |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| BUSINESS OPP | FACT_BUSINESS_OPP_TM | FACT_BUSINESS_OPP_BI | FACT_BUSINESS_OPP | Data Mart |